--------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  D:\users\llochner\Dropbox\JOINT PROJECTS\JPE_Child_Devp_2020\FINAL_Replication_CLMP_JPE\code\data_cleaning\pred_wage_inst
> rument\logs\wage_construction.log
  log type:  text
 opened on:   9 Jul 2025, 13:40:33

. 
. summ uhrswork,d

                 Usual hours worked per week
-------------------------------------------------------------
      Percentiles      Smallest
 1%            0              0
 5%            0              0
10%            0              0       Obs          14,081,466
25%            0              0       Sum of Wgt.    14081466

50%           15                      Mean           20.82048
                        Largest       Std. Dev.       21.7739
75%           40             99
90%           48             99       Variance       474.1028
95%           55             99       Skewness       .3838499
99%           70             99       Kurtosis        1.78354

. replace uhrswork = . if uhrswork ==0
(6,648,890 real changes made, 6,648,890 to missing)

. summ uhrswork,d

                 Usual hours worked per week
-------------------------------------------------------------
      Percentiles      Smallest
 1%            6              1
 5%           15              1
10%           20              1       Obs           7,432,576
25%           36              1       Sum of Wgt.   7,432,576

50%           40                      Mean           39.44567
                        Largest       Std. Dev.      12.78802
75%           45             99
90%           52             99       Variance       163.5336
95%           60             99       Skewness      -.0083521
99%           79             99       Kurtosis       4.935837

. 
. summ wkswork1,d

                   Weeks worked last year
-------------------------------------------------------------
      Percentiles      Smallest
 1%            0              0
 5%            0              0
10%            0              0       Obs          14,081,466
25%            0              0       Sum of Wgt.    14081466

50%           12                      Mean           23.38998
                        Largest       Std. Dev.       24.1859
75%           52             52
90%           52             52       Variance       584.9576
95%           52             52       Skewness       .1805814
99%           52             52       Kurtosis       1.136348

. replace wkswork1 = . if wkswork1 ==0
(6,648,890 real changes made, 6,648,890 to missing)

. summ wkswork1,d

                   Weeks worked last year
-------------------------------------------------------------
      Percentiles      Smallest
 1%            3              1
 5%           12              1
10%           20              1       Obs           7,432,576
25%           41              1       Sum of Wgt.   7,432,576

50%           52                      Mean           44.31373
                        Largest       Std. Dev.      13.45466
75%           52             52
90%           52             52       Variance       181.0278
95%           52             52       Skewness      -1.739312
99%           52             52       Kurtosis       4.768765

. 
. summ incwage,d

                   Wage and salary income
-------------------------------------------------------------
      Percentiles      Smallest
 1%            0              0
 5%            0              0
10%            0              0       Obs          14,081,466
25%            0              0       Sum of Wgt.    14081466

50%        20000                      Mean           231215.5
                        Largest       Std. Dev.      404340.4
75%        70000         999999
90%       999999         999999       Variance       1.63e+11
95%       999999         999999       Skewness       1.364641
99%       999999         999999       Kurtosis       2.884149

. replace incwage =. if incwage == 0 | incwage >= 999999 
(7,106,414 real changes made, 7,106,414 to missing)

. summ incwage,d

                   Wage and salary income
-------------------------------------------------------------
      Percentiles      Smallest
 1%          400              4
 5%         1800              4
10%         3800              4       Obs           6,975,052
25%        11000              4       Sum of Wgt.   6,975,052

50%        23100                      Mean           31184.66
                        Largest       Std. Dev.      37636.91
75%        40000         385000
90%        60000         385000       Variance       1.42e+09
95%        80000         385000       Skewness       4.853795
99%       170000         385000       Kurtosis       35.94205

. 
. assert inrange(incwage,1,400000) if incwage !=.

. assert inrange(uhrswork,1,99) if uhrswork !=.

. 
. gen wage = incwage/(wkswork1*uhrswork)
(7,106,414 missing values generated)

. summ wage, d

                            wage
-------------------------------------------------------------
      Percentiles      Smallest
 1%      1.98718        .000777
 5%     3.846154       .0008013
10%     5.096419       .0009158       Obs           6,975,052
25%     7.738095       .0009615       Sum of Wgt.   6,975,052

50%         12.5                      Mean           18.60072
                        Largest       Std. Dev.      231.6778
75%     19.61539         160500
90%     30.47337         162000       Variance        53674.6
95%     40.86538         320000       Skewness       998.6439
99%     121.9231         336000       Kurtosis        1265875

. 
. assert wage > 0

. gen lnwage = log(wage)
(7,106,414 missing values generated)

. summ wage lnwage,d

                            wage
-------------------------------------------------------------
      Percentiles      Smallest
 1%      1.98718        .000777
 5%     3.846154       .0008013
10%     5.096419       .0009158       Obs           6,975,052
25%     7.738095       .0009615       Sum of Wgt.   6,975,052

50%         12.5                      Mean           18.60072
                        Largest       Std. Dev.      231.6778
75%     19.61539         160500
90%     30.47337         162000       Variance        53674.6
95%     40.86538         320000       Skewness       998.6439
99%     121.9231         336000       Kurtosis        1265875

                           lnwage
-------------------------------------------------------------
      Percentiles      Smallest
 1%     .6867163      -7.160069
 5%     1.347074      -7.129298
10%     1.628538      -6.995766       Obs           6,975,052
25%     2.046155      -6.946976       Sum of Wgt.   6,975,052

50%     2.525729                      Mean           2.529198
                        Largest       Std. Dev.      .7716545
75%     2.976314       11.98605
90%     3.416853       11.99535       Variance       .5954507
95%     3.710283       12.67608       Skewness       .1865534
99%     4.803391       12.72487       Kurtosis       6.353708

. 
. label var wage "wage = incwage/(wkswork1*uhrswork)"

. label var lnwage "log(wage)"

. 
. log close 
      name:  <unnamed>
       log:  D:\users\llochner\Dropbox\JOINT PROJECTS\JPE_Child_Devp_2020\FINAL_Replication_CLMP_JPE\code\data_cleaning\pred_wage_inst
> rument\logs\wage_construction.log
  log type:  text
 closed on:   9 Jul 2025, 13:41:14
--------------------------------------------------------------------------------------------------------------------------------------
